Query Performance Optimization
Why Are Queries Slow?
Slow Query Basics: Optimize Data Access
Are You Asking the Database for Data You Don’t Need?
Is MySQL Examining Too Much Data?
Ways to Restructure Queries
Complex Queries Versus Many Queries
Chopping Up a Query
Join Decomposition
Query Execution Basics
The MySQL Client/Server Protocol
Query States
The Query Optimization Process
The Query Execution Engine
Returning Results to the Client
Limitations of the MySQL Query Optimizer
UNION Limitations
Equality Propagation
Parallel Execution
SELECT and UPDATE on the Same Table
Optimizing Specific Types of Queries
Optimizing COUNT() Queries
Optimizing JOIN Queries
Optimizing GROUP BY with ROLLUP
Optimizing LIMIT and OFFSET
Optimizing SQL_CALC_FOUND_ROWS
Optimizing UNION
Summary